Nick Korna

Nick Korna

Nick Korna Community Champion

Overview

Overview
Roles
Member
Badges26

About Me

About Me
Not much happening here, yet.

Analytics

832
1,582
2.6k
  • Re: IF/OR Formula Issue with writing

    Hi @Lydia Bowman, If your projects are being displayed on a single row, then you could use something like this: =IF(HAS([Add-ons]@row, "Prebill"), [Total Project Cost]@row - [Prebill Actual…
    ·
  • Re: Counting Blank Cells

    If your cells are blank, then this should work: =COUNTIF({Status Blank}, "") However, this will also capture any blank rows (such as those at the bottom of your sheet, so I would use an alt…
    ·
  • Re: Using CountIfs for months and year

    Hi @Hawk23, If you have helper columns for year/month in your first sheet (the sheet for the totals), you don't need them in the data sheet and can use the Created column for both. For example, with …
    ·
  • Re: Formula for text string

    Hi @BullandKhmer, You can do this with a bunch of hidden columns, but you will also need to add some for where you have assessments on the same date (such as Dave in the example): Here the As1order-A…
    ·
  • Re: Index(Collect( Formula Help

    Hi @SergeantPup, It should be something like this, using the (hopefully!) relevant column names in the cross sheet references: =INDEX(COLLECT({Team Capacity Points}, {Iteration Name}, [Iteration Name…
    ·
Default Avatar

Badges

  • Community 10th Anniversary
  • Second Anniversary
  • Grid View
  • 250 Answers
  • Innovator
  • 25 Insightfuls
  • $1B in annualized recurring revenue
  • 100 Awesomes
  • 500 Comments
  • Question of the Month: August Participant
  • 25 Up Votes
  • First Anniversary
  • 100 Answers
  • Community Champions
  • 25 Awesomes
  • 50 Answers
  • 5 Insightfuls
  • 100 Comments
  • 25 Answers
  • 5 Up Votes